StudentRefundCalculation 
EntityType  Independent 
Logical Entity Name  StudentRefundCalculation 
Default Table Name  SaRefundCalc 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentRefundCalculation Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentRefundCalculationId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
EffectiveDate    DATETIME  YES 
 
CalculationDate    DATETIME  YES 
 
Description    VARCHAR(50)  NO 
 
Type    CHAR(1)  NO 
 
Status    CHAR(1)  NO 
 
CalculationPeriod    CHAR(1)  NO 
 
TermId(FK)    INTEGER  YES 
 
AcademicYearSequence    TINYINT  YES 
 
Note    VARCHAR(2000)  YES 
 
RefundsPayableDueDate    DATETIME  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentRt4CalculationId(FK)    INTEGER  YES 
 
LastDateOfAttendance    DATETIME  YES 
 
IsRt4CalculationNotRequired    BIT  NO 
 
EligibilityStatus    CHAR(1)  NO 
 
IsCalculationAutoApproved    BIT  NO 
 
RefundCalculationStatusId(FK)    INTEGER  YES 
 
RefundCalculationActionId(FK)    INTEGER  YES 
 
ApprovedDate    DATETIME  YES 
 
NSLDSWithdrawalDate    DATETIME  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
Rt4CalculationPeriod    CHAR(1)  YES 
 
CeasedAttendingDate    DATETIME  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 

StudentRefundCalculation Keys 
Key Name  Key Type  Keys 
SaRefundCalc_SaRefundCalcID_U_C_IDX  PrimaryKey  StudentRefundCalculationId 
SaRefundCalc_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 
Nk_SaRefundCalcSaRefundCalculationStatusId_SaRefundCalculationStatusSaRefundCalculationStatusId  Inversion Entry  RefundCalculationStatusId 

StudentRefundCalculation Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRt4Calculation  Non-Identifying  Zero or One to Zero or More        StudentRt4CalculationId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SaRefundCalcStudentGroup_FAA  Non-Identifying  One To Zero or More          NO 
SaRefundCalcStudentGroup  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationAssignment  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
StipendSchedule  Non-Identifying  One To Zero or More          NO 
StudentRefundCalculationPolicySummary  Non-Identifying  One To Zero or More          NO 

StudentRefundCalculation Check Constraints 
Check Constraint Name  CheckConstraint 

StudentRefundCalculation Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentRefundCalculation 
NO       
Physical (Microsoft SQL Server)
dbo.SaRefundCalc 
NO       

StudentRefundCalculation Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  RefundCalculation 
Logical  Refunds_Stipends 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Student Accounts 

StudentRefundCalculation Data Movement Rules 
Name  Type  Rule Text/Value